/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-05-04 17:36:07
*/


-- ----------------------------
-- Table structure for tb0189
-- ----------------------------
DROP TABLE [dbo].[tb0189]
GO
CREATE TABLE [dbo].[tb0189] (
[ID] int IDENTITY(1,1) NOT NULL,
[ReportID] varchar(20) NOT NULL ,
[ReportName] nvarchar(150) NULL ,
[Title] nvarchar(250) NULL ,
[GroupID] varchar(20) NOT NULL ,
[Type] tinyint NOT NULL ,
[Disabled] tinyint NOT NULL ,
[SQLstring] nvarchar(500) NULL ,
[Orderby] nvarchar(500) NULL ,
[Description] nvarchar(250) NULL ,
[DescriptionE] nvarchar(800) NULL ,
[TitleE] nvarchar(250) NULL ,
[ReportNameE] nvarchar(150) NULL ,
[GroupShow] nvarchar(300) NULL 
)


GO

-- ----------------------------
-- Records of tb0189
-- ----------------------------
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0292', N'Chi tieát nôï phaûi traû', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'11', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0012', N'Ñoái chieáu coâng nôï (toång hôïp theo maët haøng)', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'G03', N'4', N'0', N'Select * From vi0066 ', N'Order by GroupID, TransactionTypeID, VoucherDate', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'Compare Receivable and Payable on Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0303', N'Toång hôïp Nôï phaûi traû (Ngoaïi teä)', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'20', N'0', N'Select * from vi0282 ', N' Order by GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt (Foreign currency)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0183', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0314', N'Nhaät kyù chung (A4L)', N'NHAÄT KYÙ CHUNG', N'G99', N'5', N'0', null, null, N'NHAÄT KYÙ CHUNG', N'JOURNAL LISTING', N'JOURNAL LISTING', N'Journal Listing', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0223', N'Baùo caùo coâng nôï theo maõ phaân tích (saùu coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'46', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0329', N'Nhaät kyù thu chi qua ngaân haøng theo ngaøy (nguyeân teä)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * From vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Original)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0175', N'Baùo caùo chi tieát doanh soá baùn haøng theo mao phaân tích (khoâng nhoùm theo maët haøng)', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'G07', N'7', N'0', N'Select * From vi0221 ', N' Order By Group1ID, Group2ID, Group3ID', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'Analysis Code Sales', N'Analysis Code Sales', N'Analysis Code Sales', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0231', N'Baùo caùo chi tieát phaùt sinh theo mao phaân tích (toång hôïp 1)', N'CHI TIEÁT PHAÙT SINH', N'G99', N'9', N'0', N'Select * from vi0254 Order by AnaID, VoucherDate, VoucherNo ', null, N'CHI TIEÁT PHAÙT SINH', N'ANALYSIS TRANSACTION', N'ANALYSIS TRANSACTION', N'Analysis Transaction', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0225', N'Baùo caùo coâng nôï theo maõ phaân tích (taùm coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'48', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0148', N'Baùo caùo doanh soá baùn haøng', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'G07', N'3', N'0', N'Select * From vi0198 Order by ObjectID, InvoiceNo', null, N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0302', N'Chi tieát nôï phaûi traû (Ngteä - quy ñoåi)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable (Original - Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0156', N'Baùo caùo haøng baùn traû laïi', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'G07', N'22', N'0', N'Select * From vi0213 ', N' Order by ObjectID, InvoiceNo', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'RETURN GOODS', N'RETURN GOODS', N'Return Goods', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0319', N'Toång hôïp Nôï phaûi thu (taát caû loaïi tieàn - Qui ñoåi)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'10', N'0', N'Select * from vi0277 ', N' Order by GroupID,GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0004', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'0', N'Select * from vi0049', N' Order by InventoryID', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (By Month)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0297', N'Chi tieát nôï phaûi thu (Nguyeân teä - Qui ñoåi)', N'BAÛNG KEÂ ÑOÁI CHIEÁU NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'BAÛNG KEÂ ÑOÁI CHIEÁU NÔÏ PHAÛI THU', N'TO COMPARE RECEIVABLE', N'TO COMPARE RECEIVABLE', N'To Compare Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0350', N'Baûng keát quaû kinh doanh theo ngaân saùch', N'KEÁT QUAÛ KINH DOANH THEO NGAÂN SAÙCH', N'G99', N'54', N'0', null, null, N'Baûng keát quaû kinh doanh theo ngaân saùch', N'', N'PROFIT & LOSS ON BUDGET', N'PROFIT & LOSS ON BUDGET', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0108', N'Baùo caùo danh saùch coâng cuï duïng cuï', N'DANH SAÙCH COÂNG CUÏ DUÏNG CUÏ', N'G08', N'1', N'0', N'Select * From vi0141', N'Order by GroupID, ToolID', N'DANH SAÙCH COÂNG CUÏ DUÏNG CUÏ', N'Equipment list', N'EQUIPMENT LIST', N'Equipment list', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0109', N'T`NH H`NH TAÊNG GÆAM TSCÑ', N'T`NH H`NH TAÊNG GIAÛI TSCÑ', N'G02', N'2', N'0', N'', N'', N'T`NH H`NH TAÊNG GIAÛI TSCÑ', N'T`NH H`NH TAÊNG GIAÛI TSCÑ', N'T`NH H`NH TAÊNG GIAÛI TSCÑ', N'T`NH H`NH TAÊNG GÆAM TSCÑ', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0235', N'Baùo caùo phaân tích TC daïng 3 (Khoâng nhoùm; 04 coät)', null, N'G99', N'33', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0099', N'Baùo caùo khaáu hao trong kyø', N'KHAÁU HAO TAØI SAÛN COÁ Ñ?NH', N'G02', N'0', N'0', N'Select * From vi0130 ', N'Order By  GroupID, AssetID', N'Baùo caùo khaáu hao TSCÑ', N'Fix Asset depreciation', N'FIX ASSET DEPRECIATION', N'Fix Asset depreciation', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0313', N'Toång hôïp Nôï phaûi traû (tieàn haïch toaùn)', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'10', N'0', N'Select * from vi0282', N' Order by GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0287', N'Baûng keâ haøng hoaù dòch vuï mua vaøo coù hoaù ñôn (maãu 05)', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0189', N'Baùo caùo chi tieát theo hoaù ñôn', N'BAÙO CAÙO CHI TIEÁT THEO HOAÙ ÑÔN', N'G99', N'40', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0228', N'Soå chi tieát baùn haøng (NKSC)', N'SOÅ CHI TIEÁT BAÙN HAØNG', N'G07', N'28', N'0', N'Select * from vi0251 Order by InventoryID, VoucherDate', null, N'SOÅ CHI TIEÁT BAÙN HAØNG', N'DETAIL ON SALES BOOKS', N'DETAIL ON SALES BOOKS', N'Detail on Sales Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0338', N'Baùo caùo keát quaû kinh doanh (Phaàn III)', N'BAÙO CAÙO KEÁT QUAÛ KINH DOANH', N'G99', N'27', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0186', N'Baùo caùo phaân tích taøi chính daïng 1 (04 coät)', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1 (04 coät)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0171', N'Baùo caùo toång hôïp doanh soá baùn haøng theo maõ phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAÕ PHAÂN TÍCH', N'G07', N'26', N'0', N'Select * From vi0221 ', N' Order By Group1ID', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0024', N'Baùo caùo toång hôïp phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO TOÅNG HÔÏP PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'15', N'0', N'Select * From vi0073 Order By Group1, ObjectID', null, N'BAÙO CAÙO TOÅNG HÔÏP PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0241', N'Soå chi tieát chi phí (nhoùm)', N'CHI TIEÁT CHI PHÍ', N'G06', N'1', N'0', N'Select * From vi0256 Order by GroupID, VoucherDate, VoucherNo', null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0002', N'Thanh toaùn trea haïn, tröôùc haïn', N'THANH TOAÙN TREA HAÏN, TRÖÔÙC HAÏN', N'G03', N'37', N'0', N'Select * from vi0049 ', N'Order by GroupID,ObjectID', N'THANH TOAÙN TREA HAÏN, TRÖÔÙC HAÏN', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0401', N'Nhaäp xuaát toàn', N'SOÅ CHI TIEÁT VAÄT TÖ', N'G05', N'2', N'0', N'select * from vi0401', N'ORDER BY InventoryID', N'SOÅ CHI TIEÁT VAÄT TÖ', N'INVENTORY BOOKS', N'INVENTORY BOOKS', N'Inventory Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0404', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'1', N'Select * from vi0049', N'Order by InventoryID', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (By Month)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0405', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'1', N'Select * from vi0049', N'Order by InventoryID', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (By Month)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0407', N'Chi tieát nôï phaûi thu (taùch trang)', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0412', N'Soå chi tieát vaät lieäu (saûn phaåm, haøng hoùa) (NKSC)', N'SOÅ CHI TIEÁT VAÄT LIEÄU (SAÛN PHAÅM, HAØNG HOÙA)', N'G05', N'6', N'1', N'Select * from AT2015 Order by AccountID, WarehouseID, InventoryID, Orders', N'', N'SOÅ CHI TIEÁT VAÄT LIEÄU (SAÛN PHAÅM, HAØNG HOÙA)', N'DETAIL ON MATERIALS BOOKS', N'DETAIL ON MATERIALS BOOKS', N'Detail on Materials Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0289', N'Baûng keâ haøng mua vaøo khoâng coù hoaù ñôn', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0286', N'Baûng keâ haøng hoaù dòch vuï mua vaøo (maãu 03)', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0034', N'Chi tieát thanh toaùn nôï phaûi traû (A4L)', N'CHI TIEÁT THANH TOAÙN NÔÏ PHAÛI TRAÛ', N'G04', N'2', N'0', N'Select * From vi0101 ', N' order by GroupID, CreditVoucherDate,BatchID, DebitVoucherNo', N'CHI TIEÁT THANH TOAÙN NÔÏ PHAÛI TRAÛ', N'DETAIL OF PAYABLE PROCESS', N'DETAIL OF PAYABLE PROCESS', N'Detail of Payable Process', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0370', N'Baùo caùo phaân tích toàn kho (möôøi chín coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0202', N'Baùo caùo coâng nôï theo maõ phaân tích (ba coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'43', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0215', N'Baùo caùo coâng nôï theo maõ phaân tích (7 coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'47', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0311', N'Soå chi tieát thanh toaùn vôùi ngöôøi mua baèng ngoaïi teä (NKSC)', N'SOÅ CHI TIEÁT THANH TOAÙN VÔÙI NGÖÔØI MUA BAÈNG NGOAÏI TEÄ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'SOÅ CHI TIEÁT THANH TOAÙN VÔÙI NGÖÔØI MUA BAÈNG NGOAÏI TEÄ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0323', N'Nhaät kyù thu chi phieáu (quy ñoåi)', N'NHAÄT KYÙ THU - CHI', N'G01', N'0', N'0', N'Select * from vi0297 ', N'Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo ', N'NHAÄT KYÙ THU - CHI', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0264', N'Soå caùi chi tieát (coäng sau moai thaùng)-A4L', N'SOÅ CAÙI CHI TIEÁT', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0324', N'Nhaät kyù thu chi ngaøy', N'NHAÄT KYÙ THU CHI NGAØY', N'G01', N'0', N'0', N'Select * from vi0297 ', N'Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo ', N'NHAÄT KYÙ THU CHI NGAØY', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0015', N'Ñoái chieáu coâng nôï (A4L)', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'G03', N'3', N'0', N'select * from vi0067 ', N'Order by GroupID, VoucherDate, VoucherNo, TransactionTypeID,Orders ', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'Compare Receivable and Payable on Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0233', N'Baùo caùo phaân tích TC daïng 2 (Khoâng nhoùm; 02 coät)', N'Baùo caùo phaân tích TC daïng 2 (Khoâng nhoùm; 02 coät)', N'G99', N'10', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0275', N'Chi tieát nôï phaûi thu (taùch trang)', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0243', N'Details of cash flow', N'DETAILS OF CASH FLOW', N'G99', N'8', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0173', N'Baùo caùo chi tieát doanh soá baùn haøng theo maõ phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAÕ PHAÂN TÍCH', N'G07', N'17', N'0', N'Select * From vi0221 ', N' Order By Group1ID, Group2ID', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0023', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'25', N'0', N'Select * From vi0073 Order By Group1, Group2, ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0025', N'Baùo caùo toång hôïp phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO TOÅNG HÔÏP PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'5', N'0', N'Select * From vi0073 Order By ObjectID', null, N'BAÙO CÁO T?NG H?P PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0116', N'Soå chi tieát vaät lieäu (saûn phaåm, haøng hoùa) (NKSC)', N'SOÅ CHI TIEÁT VAÄT LIEÄU (SAÛN PHAÅM, HAØNG HOÙA)', N'G05', N'6', N'0', N'Select * from tb0112 Order by AccountID, WarehouseID, InventoryID, Orders', null, N'SOÅ CHI TIEÁT VAÄT LIEÄU (SAÛN PHAÅM, HAØNG HOÙA)', N'DETAIL ON MATERIALS BOOKS', N'DETAIL ON MATERIALS BOOKS', N'Detail on Materials Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0117', N'Baùo caùo toàn kho theo taøi khoaûn', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'G05', N'0', N'0', N'Select * From vi0149 ', N' Order by InventoryID', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'Receiving - Delivering - Inventory (By Account)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0246', N'Baùo caùo nhaäp xuaát toàn theo kho', N'NHAÏP XUAÁT TOÀN THEO KHO', N'G05', N'4', N'0', N'Select * from vi0150 ', N' Order by  GroupID1, GroupID2,  InventoryID', N'NHAÏP XUAÁT TOÀN THEO KHO', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0375', N'Baùo caùo luyo keá toàn kho (20 coät)', N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', N'G05', N'22', N'0', null, null, N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0266', N'Soå chi tieát caùc taøi khoaûn (NKSC)', N'SOÅ CHI TIEÁT CAÙC TAØI KHOAÛN', N'G99', N'16', N'0', N'Select * from tb0148 Order by AccountID, ObjectID, Orders', null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt2053', N'Danh s¸ch nh©n viªn (MÉu 2)', N'Danh saùch nhaân vieân', N'G09', N'0', N'0', N'Select * From vi2513', N'DepartmentID, Orders', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0298', N'Toång hôïp Nôï phaûi thu (tieàn haïch toaùn)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'20', N'0', N' Select * from vi0277 ', N' Order by GroupID,GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0208', N'Baùo caùo coâng nôï theo maõ phaân tích (9 coät, 2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'49', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0265', N'Soå caùi chi tieát (coäng sau moai thaùng)-A4L ', N'SOÅ CAÙI CHI TIEÁT', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0157', N'Baùo caùo haøng baùn traû laïi', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'G07', N'21', N'0', N'Select * From vi0210 ', N' Order by GROUPID, InventoryID', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'RETURN GOODS', N'RETURN GOODS', N'Return Goods', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0343', N'Soå caùi taøi khoaûn', N'SOÅ CAÙI TAØI KHOAÛN ', N'G99', N'52', N'0', N'Select * from vi0389 ', N'Order by AccountID,BookDate,BookNo', N'Baùo caùo soå caùi taøi khoaûn', N'Baùo caùo soå caùi taøi khoaûn', N'SOÅ CAÙI TAØI KHOAÛN ', N'Soå caùi taøi khoaûn', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0382', N'Baûng caân ñoái keá toaùn nhieàu coät', N'BAÛNG CAÂN ÑOÁI KEÁ TOAÙN NHIEÀU COÄT', N'G99', N'3', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0254', N'Nhaät kyù nhaäp xuaát kho - aâm', N'NHAÄT KYÙ NHAÄP XUAÁT KHO - AÂM', N'G05', N'3', N'1', N'Select * from tb0111 Where InventoryID in (select InventoryID from tb0111 Where EndQuantity < 0)', N'Order by WareHouseID, InventoryID, Orders', N'NHAÄT KYÙ NHAÄP XUAÁT KHO - AÂM', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'Receiving - Delivering - Inventory Diary', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0115', N'Baùo caùo phaân boå doanh thu vaø chi phí', N'PHAÂN BOÅ DOANH THU VAØ CHI PHÍ', N'G99', N'20', N'0', N'Select * From vi0147', N'Order by GroupID, JobID', N'PHAÂN BOÅ DOANH THU VAØ CHI PHÍ', N'Sales and cost apportion', N'SALES AND COST APPORTION', N'Sales and cost apportion', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0261', N'Soå caùi - chi tieát - maau 2 (A4L)', N'SOÅ CAÙI CHI TIEÁT TAØI KHOAÛN', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT TAØI KHOAÛN', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0365', N'Baùo caùo phaân tích toàn kho (möôøi  boán coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0206', N'Baùo caùo coâng nôï theo maõ phaân tích ( 7 coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'47', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0029', N'Baùo caùo toång hôïp ñoái chieáu coâng nôï phaûi thu vaø phaûi traû', N'BAÙO CAÙO TOÅNG HÔÏP ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'G04', N'4', N'0', N'Select * From vi0088 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'BAÙO CAÙO TOÅNG HÔÏP ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0317', N'Nhaät kyù soå caùi', N'NHAÄT KYÙ SOÅ CAÙI', N'G99', N'15', N'0', null, null, N'NHAÄT KYÙ SOÅ CAÙI', N'LEDGER JOURNAL', N'LEDGER JOURNAL', N'Ledger Journal', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0153', N'Baùo caùo haøng baùn traû laïi', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'G07', N'11', N'0', N'Select * From vi0208 ', N'Order by InventoryID, InvoiceDate', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'RETURN GOODS', N'RETURN GOODS', N'Return Goods', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0400', N'Baùo caùo xuaát kho theo boä', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', N'G05', N'12', N'1', N'Select * From AT7025', N'VoucherDate', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0402', N'Baùo caùo nhaäp xuaát toàn taát caû caùc kho', N'NHAÄP XUAÁT TOÀN', N'G05', N'5', N'1', N'Select * from vi0182', N'Order by  GroupID1, GroupID2, InventoryID', N'NHAÄP XUAÁT TOÀN', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0238', N'Baùo caùo phaân tích TC daïng 3 (04 coät, 2 nhoùm)', N'BAÙO CAÙO', N'G99', N'33', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0245', N'Baùo caùo doanh thu - coâng nôï theo ñoái töôïng', N'BAÙO CAÙO DOANH THU - COÂNG NÔÏ THEO ÑOÁI TÖÔÏNG', N'G99', N'66', N'0', N'Select * from vi0257 ', N' Order by GroupID1, GroupID2, ObjectID', N'BAÙO CAÙO DOANH THU - COÂNG NÔÏ THEO ÑOÁI TÖÔÏNG', N'SALES - RECEIVABLED & PAYABLED BY OBJECT', N'SALES - RECEIVABLED & PAYABLED BY OBJECT', N'Sales - Receivabled & payabled by object', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0026', N'T´nh h´nh thanh toaùn (A4L)', N'TOÅNG HÔÏP TÌNH HÌNH THANH TOAÙN', N'G03', N'8', N'0', N'Select * From vi0091', N'Order by ObjectID', N'TOÅNG HÔÏP T`NH H`NH THANH TOAÙN', N'GENERAL OF RECEIVABLE PROCESS', N'GENERAL OF RECEIVABLE PROCESS', N'General of Receivable Process', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0331', N'Soå tieàn göûi ngaân haøng (toång hôïp)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'2', N'0', N'Select * from vi0302 ', N' Order by TransactionTypeID', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'CASH IN BANK BOOK (GENERAL)', N'CASH IN BANK BOOK (GENERAL)', N'Cash in Bank Book (General)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0394', N'Soå taøi khoaûn ngoaøi baûng (chi tieát)', N'SOÅ TAØI KHOAÛN NGOAØI BAÛNG', N'G99', N'95', N'0', N'Select * from vi0382', N'Order by AccountID', N'SOÅ TAØI KHOAÛN NGOAØI BAÛNG', N'OUT TABLE ACCOUNT TABLE', N'OUT TABLE ACCOUNT TABLE', N'Out table account book (detail)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0403', N'Baùo caùo chi tieát theo phieáu', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'G05', N'24', N'1', N'Select * from vi0060', N'Order by WareHouseID,InventoryID,ReVoucherDate,ReVoucherNo,ResourceNo,DeVoucherDate,DeVoucherNo', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'Receiving - Delivering - Inventory (By Lot)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0406', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'1', N'', N'', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0005', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'G05', N'24', N'1', N'', N'', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0409', N'Nhaäp xuaát toàn theo ñoái töôïng', N'NHAÄP XUAÁT TOÀN THEO ÑOÁI TÖÔÏNG', N'G05', N'18', N'1', N'Select * from vi0107', N'Order by  ObjectID', N'NHAÄP XUAÁT TOÀN THEO ÑOÁI TÖÔÏNG', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(By Object)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0410', N'Baùo caùo toàn kho theo taøi khoaûn', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'G05', N'0', N'0', N'Select * From vi0149 ', N' Order by InventoryID', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'Receiving - Delivering - Inventory (By Account)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0413', N'Nhaäp xuaát toàn chi tieát theo ñoái töôïng', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'G05', N'28', N'1', N'Select * from vi0108', N'Order by  ObjectID, right(SourceNo,4)', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(By Object)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0416', N'Baùo caùo doanh soá baùn haøng', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'G07', N'0', N'0', N'Select * From vi0192 Order by InventoryID, InvoiceDate', N'Order by InvoiceDate', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0276', N'Chi tieát nôï phaûi thu (theo mat hang)', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * FROM vi0279', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0000', N'Baùo caùo chi tieát theo loâ', N'BAÙO CAÙO NHAÄP XUAÂT TOÀN CHI TIEÁT THEO LOÂ', N'G05', N'1', N'0', N'Select * from vi0046', N' Order by WareHouseID,InventoryID', N'BAÙO CAÙO NHAÄP XUAÂT TOÀN CHI TIEÁT THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'Receiving - Delivering - Inventory (By Lot)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0013', N'Ñoái chieáu coâng nôï (A4P)', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'G03', N'3', N'0', N'SELECT * FROM vi0067', N'Order by GroupID, VoucherDate, VoucherNo, TransactionTypeID,Orders ', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'Compare Receivable and Payable on Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0278', N'Toång hôïp Nôï phaûi thu (ngoaïi teä - nguyeân teä)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'0', N'0', N'Select * from vi0277 ', N' Order by GroupID,GroupID1, GroupID2', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0283', N'Toång hôïp Nôï phaûi traû (taát caû)', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'0', N'0', N'Select * from vi0282 ', N' Order by GroupID1, GroupID2', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt (All)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0016', N'T´nh h´nh thanh toaùn (A4L)', N'CHI TIEÁT TÌNH HÌNH THANH TOAÙN', N'G03', N'2', N'0', N'Select * From vi0070 Order By DebitVoucherDate,CreditVoucherDate', N'', N'CHI TIEÁT T`NH H`NH THANH TOAÙN', N'DETAIL OF RECEIVABLE PROCESS', N'DETAIL OF RECEIVABLE PROCESS', N'Detail of Receivable Process', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0145', N'Baùo caùo doanh soá baùn haøng', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'G07', N'0', N'0', N'Select * From vi0192 Order by InventoryID, InvoiceDate', null, N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0199', N'Baùo caùo toång hôïp theo ngaøy', N'BAÙO CAÙO TOÅNG HÔÏP THEO NGAØY', N'G99', N'50', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0367', N'Baùo caùo phaân tích toàn kho (möôøi saùu coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0368', N'Baùo caùo phaân tích toàn kho (möôøi  baûy coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0373', N'Baùo caùo luyo keá toàn kho (6 coät)', N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', N'G05', N'22', N'0', null, null, N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0188', N'Baùo caùo phaân tích taøi chính daïng 1 (04 caáp)', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1 (04 caáp)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0218', N'Baùo caùo coâng nôï theo maõ phaân tích (moät coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'41', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0219', N'Baùo caùo coâng nôï theo maõ phaân tích (hai coät,boán caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'42', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0224', N'Baùo caùo coâng nôï theo maõ phaân tích (7 coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'47', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0230', N'Soå theo dooi thueá GTGT (NKSC)', N'SOÅ THEO DOOI THUEÁ GIAÙ TR? GIA TAÊNG', N'G99', N'14', N'0', N'Select * from vi0252 Order by VoucherDate', null, N'SOÅ THEO DOOI THUEÁ GIAÙ TR? GIA TAÊNG', N'VAT MANAGEMENT BOOK', N'VAT MANAGEMENT BOOK', N'VAT Management Book', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0249', N'Baùo caùo phaân tích toàn kho (Chi tieát)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'15', N'0', N'Select tb0147.*, vi0371.* from tb0147 inner join vi0371 on vi0371.ColumnID = tb0147.ColumnID', N'AT7005.InventoryID, AT7005.VoucherDate, AT7005.VoucherNo, vi0371.Orders, vi0371.Type ', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0097', N'Baùo caùo khaáu hao trong kyø', N'KHAÁU HAO TAØI SAÛN COÁ Ñ?NH', N'G02', N'0', N'0', N'Select * From vi0130 ', N'Order By  GroupID, AssetID', N'Baùo caùo khaáu hao TSCÑ', N'Fix Asset depreciation', N'FIX ASSET DEPRECIATION', N'Fix Asset depreciation', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0253', N'Baùo caùo phaân tích toàn kho (Toång hôïp)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'16', N'0', N'Select AT7015.*, vi0371.* from tb0147 inner join vi0371 on vi0371.ColumnID = tb0147.ColumnID', N'AT7005.InventoryID, AT7005.VoucherDate, AT7005.VoucherNo, vi0371.Orders, vi0371.Type ', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0042', N'Baùo caùo toång hôïp doanh soá haøng mua nhoùm 2 caáp', N'BAÙO CAÙO TOÅNG HÔÏP DOANH SOÁ HAØNG MUA', N'G07', N'15', N'0', N'Select * From vi0104 Order by Group1ID,Group2ID', null, null, N'GENERAL PURCHASING TURNOVER', N'GENERAL PURCHASING TURNOVER', N'General Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0229', N'Baùo caùo phaân tích doanh thu', N'KHAÁU HAO COÂNG CUÏ DUÏNG CUÏ', N'G07', N'10', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0336', N'Baùo caùo keát quaû kinh doanh (phaàn I)', N'BAÙO CAÙO KEÁT QUAÛ KINH DOANH', N'G99', N'7', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0322', N'Nhaät kyù thu chi (theo phieáu)', N'NHAÄT KYÙ THU - CHI', N'G01', N'0', N'0', N'Select * from vi0297 ', N'Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo ', N'NHAÄT KYÙ THU - CHI', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0234', N'Baùo caùo phaân tích TC daïng 2 (02 coät, 1 nhoùm)', N'BAÙO CAÙO', N'G99', N'10', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0250', N'Nhaät kyù nhaäp xuaát kho', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'G05', N'3', N'0', N'Select * from tb0111 ', N' Order by WareHouseID, Orders', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'Receiving - Delivering - Inventory Diary', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0100', N'Baùo caùo khaáu hao trong kyø (theo naêm)', N'KHAÁU HAO TAØI SAÛN COÁ Ñ?NH', N'G02', N'0', N'0', N'Select * From vi0130 ', N'Order By  GroupID, AssetID', N'Baùo caùo khaáu hao TSCÑ', N'Fix Asset depreciation', N'FIX ASSET DEPRECIATION', N'Fix Asset depreciation (Year)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0262', N'Soå caùi chi tieát', N'SOÅ CAÙI CHI TIEÁT', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0263', N'Soå caùi chi tieát (coäng sau moai thaùng)-A4P ', N'SOÅ CAÙI CHI TIEÁT', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0334', N'Profit and loss statement settings', N'PROFIT AND LOSS STATEMENT SETTINGS', N'G99', N'7', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0345', N'Profit and loss statement (Part II)', N'PROFIT AND LOSS STATEMENT (PART II)', N'G99', N'17', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0172', N'Baùo caùo chi tieát doanh soá baùn haøng theo mao phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'G07', N'7', N'0', N'Select * From vi0221 ', N' Order by Group1ID,Group2ID,Group3ID', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'Analysis Code Sales', N'Analysis Code Sales', N'Analysis Code Sales', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0018', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'36', N'0', N'Select * From vi0073 Order By Group1, Group2, Group3, ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0020', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'16', N'0', N'Select * From vi0073 Order By Group1, ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0022', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'35', N'0', N'Select * From vi0073 Order By Group1, Group2, Group3, ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0273', N'Baûng caân ñoái phaùt sinh (khoâng nhoùm, khoâng in TK chi tieát)', N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'G99', N'2', N'0', null, null, N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'TRIAL BALANCE', N'TRIAL BALANCE', N'Trial Balance', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0176', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G07', N'17', N'0', N'Select * From vi0221 ', N' Order By Group1ID, Group2ID', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt2052', N'Danh s¸ch nh©n viªn (MÉu 1)', N'Danh saùch nhaân vieân', N'G09', N'0', N'0', N'Select * From vi2513', N'DepartmentID, Orders', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0304', N'Toång hôïp Nôï phaûi thu (taát caû loaïi tieàn - Qui ñoåi)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'10', N'0', N'Select * from vi0277', N' Order by GroupID,GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0098', N'Baùo caùo khaáu hao trong kyø', N'KHAÁU HAO TAØI SAÛN COÁ Ñ?NH', N'G02', N'0', N'0', N'Select * From vi0130 ', N'Order By  GroupID, AssetID', N'Baùo caùo khaáu hao TSCÑ', N'Fix Asset depreciation', N'FIX ASSET DEPRECIATION', N'Fix Asset depreciation', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0118', N'Baùo caùo toàn kho theo taøi khoaûn', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'G05', N'0', N'0', N'Select * From vi0149 ', N' Order by InventoryID', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT', N'Receiving - Delivering - Inventory (By Account)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0290', N'Chi tieát nôï phaûi thu (nguyeân teä)', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable (Original)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0300', N'Chi tieát nôï phaûi thu', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'11', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0267', N'Soå caùi - Toång hôïp', N'SOÅ CAÙI TOÅNG HÔÏP', N'G99', N'1', N'0', N'Select * from vi0271 ', N'Order by  LinkAccountID, CorAccountID ', N'SOÅ CAÙI TOÅNG HÔÏP', N'LEDGER', N'LEDGER', N'Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0207', N'Baùo caùo coâng nôï theo maõ phaân tích ( 8 coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'48', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0045', N'Nhaäp xuaát toàn theo ñoái töôïng', N'NHAÄP XUAÁT TOÀN THEO ÑOÁI TÖÔÏNG', N'G05', N'18', N'0', N'Select * from vi0107', N'Order by  ObjectID', N'NHAÄP XUAÁT TOÀN THEO ÑOÁI TÖÔÏNG', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(By Object)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0301', N'Chi tieát nôï phaûi traû (taùch trang)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0363', N'Baùo caùo phaân tích toàn kho (möôøi hai coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0191', N'Baùo caùo coâng nôï theo maõ phaân tích (hai coät,moät caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'42', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0204', N'Baùo caùo coâng nôï theo maõ phaân tích (naêm coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'45', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0038', N'Baùo caùo doanh soá haøng mua theo maët haøng (nhoùm theo ñoái töôïng)', N'BAÙO CAÙO DOANH SOÁ HAØNG MUA', N'G07', N'4', N'0', N'Select * From vi0103 Order by Group1ID,VoucherNo', null, N'BAÙO CAÙO DOANH SOÁ HAØNG MUA', N'PURCHASING TURNOVER', N'PURCHASING TURNOVER', N'Purchasing turnover group by Object', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0174', N'Baùo caùo chi tieát doanh soá baùn haøng theo maõ phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAÕ PHAÂN TÍCH', N'G07', N'27', N'0', N'Select * From vi0221', N'  Order By Group1ID', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0177', N'Baùo caùo chi tieát doanh soá baùn haøng theo maõ phaân tích (khoâng nhoùm theo maët haøng)', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAÕ PHAÂN TÍCH', N'G07', N'27', N'0', N'Select * From vi0221 ', N' Order By Group1ID', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0308', N'Toång hôïp Nôï phaûi thu (taát caû loaïi tieàn - quy ñoåi)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'10', N'0', N' Select * from vi0277', N' Order by GroupID,GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0232', N'Baùo caùo chi tieát phaùt sinh theo mao phaân tích (toång hôïp 2)', N'CHI TIEÁT PHAÙT SINH', N'G99', N'9', N'0', N'Select * from vi0254 Order by AnaID, VoucherDate, VoucherNo ', null, N'CHI TIEÁT PHAÙT SINH', N'ANALYSIS TRANSACTION', N'ANALYSIS TRANSACTION', N'Analysis Transaction', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0216', N'Baùo caùo coâng nôï theo maõ phaân tích (taùm coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'48', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0198', N'Baùo caùo coâng nôï theo maõ phaân tích (chín coät,moät caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'49', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0240', N'Soå chi tieát chi phí (Toång hôïp theo TK)', N'CHI TIEÁT CHI PHÍ', N'G06', N'0', N'0', N'Select * From vi0256 ', N'Order by AccountID', N'CHI TIEÁT CHI PHÍ', N'COST BOOKS', N'COST BOOKS', N'Cost Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0252', N'Baùo caùo nhaäp xuaát toàn theo kho (maau 2)', N'NHAÏP XUAÁT TOÀN THEO KHO', N'G05', N'4', N'0', N'Select * from vi0150 ', N' Order by  GroupID1, GroupID2,  InventoryID', N'NHAÏP XUAÁT TOÀN THEO KHO', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0001', N'Thanh toaùn trea haïn, tröôùc haïn', N'THANH TOAÙN TREA HAÏN, TRÖÔÙC HAÏN', N'G03', N'30', N'0', N'Select * from vi0048 ', N'Order by GroupID,ObjectID', N'THANH TOAÙN TREA HAÏN, TRÖÔÙC HAÏN', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0119', N'Baùo caùo nhaäp xuaát toàn theo kho (Nhoùm 1)', N'NHAÏP XUAÁT TOÀN THEO KHO', N'G05', N'4', N'0', N'Select * from vi0150 ', N' Order by  GroupID1, GroupID2,  InventoryID', N'NHAÏP XUAÁT TOÀN THEO KHO', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0152', N'Baùo caùo doanh soá baùn haøng chi tieát theo hoùa ñôan', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG CHI TIEÁT THEO HOAÙ ÑÔN', N'G07', N'1', N'0', N'Select * From vi0197 Order by InvoiceNo,InvoiceDate,ObjectID,InventoryID', null, N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG CHI TIEÁT THEO HOAÙ ÑÔN', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0103', N'Baùo caùo taêng taøi saûn', N'BAÙO CAÙO TAÊNG TAØI SAÛN', N'G02', N'1', N'0', N'Select * from vi0131  Order by GroupID, AssetID', null, N'BAÙO CAÙO TAÊNG TAØI SAÛN', N'INCREASE ASSET', N'INCREASE ASSET', N'Increase asset', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0237', N'Baùo caùo phaân tích TC daïng 3 (04 coät, 1 nhoùm)', N'BAÙO CAÙO', N'G99', N'33', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0259', N'Chi phí mua haøng', N'CHI PHÍ MUA HAØNG', N'G05', N'38', N'0', N'Select * from vi0167 ', N' Order by ObjectID, VoucherDate, VoucherNo, InventoryID', N'CHI PHÍ MUA HAØNG', N'PURCHASE COST', N'PURCHASE COST', N'Purchase cost', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0333', N'Soå mua haøng baùn haøng', N'SOÅ MUA HAØNG BAÙN HAØNG', N'G07', N'18', N'0', N'Select * from vi0304 ', N' Order by GroupID, VoucherDate, InventoryID', N'SOÅ MUA HAØNG BAÙN HAØNG', N'PURCHASE & SALE BOOK', N'PURCHASE & SALE BOOK', N'Purchase & sale book', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0332', N'Soå tieàn göûi ngaân haøng (toång hôïp, nhoùm theo ngaân haøng)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'2', N'0', N'Select * from vi0302 ', N' Order by BankAccountID, TransactionTypeID', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'CASH IN BANK BOOK (GENERAL)', N'CASH IN BANK BOOK (GENERAL)', N'Cash in Bank Book (General, group by bank)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0390', N'Soå tieàn göûi ngaân haøng (toång hôïp, nhoùm theo ngaân haøng)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'2', N'0', N'Select * from vi0302 ', N' Order by BankAccountID, TransactionTypeID', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'CASH IN BANK BOOK (GENERAL)', N'CASH IN BANK BOOK (GENERAL)', N'Cash in Bank Book (General, group by bank)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0392', N'Baùo caùo phaân tích TC daïng 2 (Nhieu Cot, Custermize)', null, N'G99', N'10', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0393', N'Baùo caùo chi tieát theo hoaù ñôn', N'BAÙO CAÙO CHI TIEÁT THEO HOAÙ ÑÔN', N'G99', N'40', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0396', N'Baûng keâ haøng hoaù dòch vuï mua vaøo (TT cuõ )', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0397', N'Baûng keâ haøng hoaù dòch vuï baùn ra coù hoaù ñôn (TT cuõ)', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0398', N'Baùo caùo chi tieát theo loâ', N'BAÙO CAÙO NHAÄP XUAÂT TOÀN CHI TIEÁT THEO LOÂ', N'G05', N'1', N'1', N'Select * from vi0046', N'Order by WareHouseID,InventoryID', N'BAÙO CAÙO NHAÄP XUAÂT TOÀN CHI TIEÁT THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'Receiving - Delivering - Inventory (By Lot)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0399', N'Baùo caùo nhaäp xuaát toàn taát caû caùc kho(nhoùm 1 caáp)', N'NHAÄP XUAÁT TOÀN', N'G05', N'5', N'1', N'Select * from vi0182', N'Order by  GroupID1, GroupID2, InventoryID', N'NHAÄP XUAÁT TOÀN', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(Level 01)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0315', N'Nhaät kyù chung (A4L - maau 2)', N'NHAÄT KYÙ CHUNG', N'G99', N'5', N'0', null, null, N'NHAÄT KYÙ CHUNG', N'JOURNAL LISTING', N'JOURNAL LISTING', N'Journal Listing', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0284', N'Toång hôïp Nôï phaûi traû ', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'0', N'0', N'Select * from vi0282 ', N' Order by GroupID1, GroupID2', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0242', N'Baùo caùo luaân chuyeån tieàn teä', N'LUAÂN CHUYEÅN TIEÀN TEÄ', N'G99', N'8', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0036', N'Baùo caùo toång hôïp doanh soá haøng mua nhoùm 1 caáp', N'BAÙO CAÙO TOÅNG HÔÏP DOANH SOÁ HAØNG MUA', N'G07', N'5', N'0', N'Select * From vi0104 Order by Group1ID ', null, null, N'GENERAL PURCHASING TURNOVER', N'GENERAL PURCHASING TURNOVER', N'General Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0044', N'Baùo caùo toång hôïp doanh soá haøng mua khoâng nhoùm', N'BAÙO CAÙO TOÅNG HÔÏP DOANH SOÁ HAØNG MUA', N'G07', N'25', N'0', N'Select * From vi0104 Order by ObjectID, InventoryID', null, null, N'GENERAL PURCHASING TURNOVER', N'GENERAL PURCHASING TURNOVER', N'General Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0031', N'Baùo caùo chi tieát ñoái chieáu coâng nôï phaûi thu', N'BIEÂN BAÛN ÑOÁI CHIEÁU COÂNG NÔÏ CAÙ NHAÂN', N'G04', N'3', N'0', N'Select * From vi0087 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'BIEÂN BAÛN ÑOÁI CHIEÁU COÂNG NÔÏ CAÙ NHAÂN', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0353', N'Baùo caùo phaân tích toàn kho (hai coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0357', N'Baùo caùo phaân tích toàn kho (Saùu coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0210', N'Baùo caùo coâng nôï theo maõ phaân tích (hai coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'42', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0222', N'Baùo caùo coâng nôï theo maõ phaân tích (naêm coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'45', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0102', N'Soå taøi saûn theo ñôn v? söû duïng (NKSC)', N'SOÅ TAØI SAÛN THEO ÑÔN V? SÖÏ DUÏNG', N'G02', N'1', N'0', N'Select * from vi0130 Order by AssetID', null, N'SOÅ TAØI SAÛN THEO ÑÔN V? SÖÏ DUÏNG', N'AssetBook of Department', N'ASSETBOOK OF DEPARTMENT', N'AssetBook of Department', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0257', N'Baùo caùo xuaát kho theo boä', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', N'G05', N'13', N'0', N'Select * From AT7025', N'ProductID, ApportionID, MaterialID', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0043', N'Baùo caùo chi tieát doanh soá haøng mua khoâng nhoùm', N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'G07', N'24', N'0', N'Select * From vi0103 Order by VoucherNo', null, N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'PURCHASING TURNOVER', N'PURCHASING TURNOVER', N'Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0033', N'Chi tieát thanh toaùn nôï phaûi traû (A4L)', N'CHI TIEÁT THANH TOAÙN NÔÏ PHAÛI TRAÛ', N'G04', N'2', N'0', N'Select * From vi0101 ', N' order by GroupID, CreditVoucherDate,BatchID, DebitVoucherNo', N'CHI TIEÁT THANH TOAÙN NÔÏ PHAÛI TRAÛ', N'DETAIL OF PAYABLE PROCESS', N'DETAIL OF PAYABLE PROCESS', N'Detail of Payable Process', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0011', N'Ñoái chieáu coâng nôï (toång hôïp theo maët haøng)', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'G03', N'4', N'0', N'Select * From vi0066 ', N'Order by GroupID, TransactionTypeID, VoucherDate', N'BAÛNG KEÂ ÑOÁI CHIEÁU COÂNG NÔÏ', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'COMPARE RECEIVABLE AND PAYABLE ON INVENTORY', N'Compare Receivable and Payable on Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0251', N'Nhaät kyù nhaäp xuaát kho', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'G05', N'3', N'1', N'Select * from tb0111', N'Order by WareHouseID, Orders', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'Receiving - Delivering - Inventory Diary', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0380', N'Details of balance sheet', N'DETAILS OF BALANCE SHEET', N'G99', N'3', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0226', N'Baùo caùo coâng nôï theo maõ phaân tích (chín coät,4 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'49', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0239', N'Soå chi tieát chi phí', N'CHI TIEÁT CHI PHÍ', N'G06', N'0', N'0', N'Select * From vi0256 ', N'Order by GroupID, VoucherDate, VoucherNo', N'CHI TIEÁT CHI PHÍ', N'COST BOOKS', N'COST BOOKS', N'Cost Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0347', N'Baûng keát quaû kinh doanh theo maõ phaân tích', N'KEÁT QUAÛ KINH DOANH THEO MAÕ PHAÂN TÍCH', N'G99', N'54', N'0', null, null, N'Baûng keát quaû kinh doanh theo maõ phaân tích', N'', N'PROFIT & LOSS', N'PROFIT & LOSS', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0154', N'Baùo caùo haøng baùn traû laïi', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'G07', N'12', N'0', N'Select * From vi0209 ', N'Order by ObjectID,InventoryID', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'RETURN GOODS', N'RETURN GOODS', N'Return Goods', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0155', N'Baùo caùo haøng baùn traû laïi', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'G07', N'21', N'0', N'Select * From vi0210 ', N'Order by InventoryID', N'BAÙO CAÙO HAØNG BAÙN TRAÛ LAÏI', N'RETURN GOODS', N'RETURN GOODS', N'Return Goods', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0003', N'Baùo caùo chi tieát theo phieáu', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'G05', N'24', N'0', N'Select * from vi0060', N' Order by WareHouseID,InventoryID,ReVoucherDate,ReVoucherNo,ResourceNo,DeVoucherDate,DeVoucherNo ', N'BAÙO CAÙO CHI TIEÁT THEO PHIEÁU', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'RECEIVING - DELIVERING - INVENTORY BY LOT', N'Receiving - Delivering - Inventory (By Lot)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0130', N'Baùo caùo chi tieát nhaäp xuaát toàn theo FIFO', N'BAÙO CAÙO CHI TIEÁT NHAÄP XUAÁT TOÀN THEO FIFO', N'G05', N'31', N'0', N'Select * from vi0181', N' Order by InventoryID,type,VoucherDate,VoucherNo,FromVoucherDate,TransactionID', N'BAÙO CAÙO CHI TIEÁT NHAÄP XUAÁT TOÀN THEO FIFO', N'RECEIVING - DELIVERING - INVENTORY BYFIFO', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (FIFO)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0046', N'Nhaäp xuaát toàn chi tieát theo ñoái töôïng', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'G05', N'28', N'0', N'Select * from vi0108', N'Order by  ObjectID, right(SourceNo,4)', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(By Object)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0339', N' Chöùng töø ghi soå', N'CHÖÙNG TÖØ GHI SOÅ ', N'G99', N'51', N'0', N'Select * from vi0388 ', N'Order by Orders,VoucherDate, VoucherNo', N'Baùo caùo chöùng töø ghi soå', N'Baùo caùo chöùng töø ghi soå', N'CHÖÙNG TÖØ GHI SOÅ ', N' Chöùng töø ghi soå', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0342', N'Ñaêng kyù chöùng töø ghi soå', N'ÑAÊNG KYÙ CHÖÙNG TÖØ GHI SOÅ', N'G99', N'53', N'0', N'Select * From vi0318', N'Order by BookDate,BookNo', N'ÑAÊNG KYÙ CHÖÙNG TÖØ GHI SOÅ', N'ÑAÊNG KYÙ CHÖÙNG TÖØ GHI SOÅ', N'ÑAÊNG KYÙ CHÖÙNG TÖØ GHI SOÅ', N'Ñaêng kyù chöùng töø ghi soå', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0149', N'Baùo caùo danh saùch hoùa ñôn', N'BAÙO CAÙO DANH SAÙCH HOÙA ÑÔN', N'G07', N'3', N'0', N'Select * From vi0198 Order by ObjectID, InvoiceNo', null, N'BAÙO CAÙO DANH SAÙCH HOÙA ÑÔN', N'INVOICE LIST', N'INVOICE LIST', N'Invoice List', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0104', N'Baùo caùo giaûm taøi saûn', N'BAÙO CAÙO GIAÛM TAØI SAÛN', N'G02', N'1', N'0', N'Select * from vi0132 WHERE ReduceDate is not null Order by GroupID, AssetID', null, N'BAÙO CAÙO GIAÛM TAØI SAÛN', N'DECREASE ASSET', N'DECREASE ASSET', N'Decrease asset', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0274', N'Baûng caân ñoái phaùt sinh (khoâng nhoùm)', N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'G99', N'2', N'0', null, null, N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'TRIAL BALANCE', N'TRIAL BALANCE', N'Trial Balance', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0047', N'Nhaäp xuaát toàn chi tieát theo ñoái töôïng', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'G05', N'28', N'0', N'Select * from vi0108 ', N' Order by  InventoryID', N'NHAÄP XUAÁT TOÀN CHI TIEÁT THEO ÑOÁI TÖÔÏNG', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(By Object)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0006', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'0', N'Select * from vi0049', N' Order by InventoryID', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (By Month)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0236', N'Baùo caùo phaân tích TC daïng 3 (04 coät, 1 nhoùm)', N'BAÙO CAÙO', N'G99', N'33', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0279', N'Toång hôïp Nôï phaûi thu (ngoaïi teä - caû Ngteä vaø quy ñoåi)', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'0', N'0', N'Select * from vi0277 ', N' Order by GroupID,GroupID1, GroupID2', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0271', N'Baûng caân ñoái phaùt sinh (khoâng nhoùm)', N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'G99', N'2', N'0', null, null, N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'TRIAL BALANCE', N'TRIAL BALANCE', N'Trial Balance', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0378', N'Baûng caân ñoái keá toaùn', N'BAÛNG CAÂN ÑOÁI KEÁ TOAÙN', N'G99', N'3', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0379', N'Balance sheet', N'BALANCE SHEET', N'G99', N'3', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0307', N'Toång hôïp Nôï phaûi traû (taát caû)', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'0', N'0', N'Select * from vi0282 ', N' Order by GroupID1, GroupID2', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt (All)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0288', N'Baûng keâ haøng hoaù dòch vuï baùn ra coù hoaù ñôn (maãu 02)', null, N'G99', N'4', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0337', N'Baùo caùo keát quaû kinh doanh (Phaàn II)', N'BAÙO CAÙO KEÁT QUAÛ KINH DOANH', N'G99', N'17', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0017', N'T´nh h´nh thanh toaùn (A4L)', N'CHI TIEÁT TÌNH HÌNH THANH TOAÙN', N'G03', N'2', N'0', N'Select * From vi0070', N'Order by GroupID, DebitVoucherDate,BatchID, CreditVoucherNo', N'CHI TIEÁT T`NH H`NH THANH TOAÙN', N'DETAIL OF RECEIVABLE PROCESS', N'DETAIL OF RECEIVABLE PROCESS', N'Detail of Receivable Process', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0133', N'Baùo caùo nhaäp xuaát toàn taát caû caùc kho(nhoùm 2 caáp)', N'NHAÄP XUAÁT TOÀN', N'G05', N'5', N'1', N'Select * from vi0182', N'Order by  GroupID1, GroupID2, InventoryID', N'NHAÄP XUAÁT TOÀN', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(Level 02)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0294', N'Chi tieát nôï phaûi traû (in lieân tuïc - nguyeân teä)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0030', N'Baùo caùo chi tieát ñoái chieáu coâng nôï phaûi thu', N'GIAÁY ÑEÀ NGH? THANH TOAÙN', N'G04', N'3', N'0', N'Select * From vi0087 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'GIAÁY ÑEÀ NGH? THANH TOAÙN', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0269', N'Soå chi tieát vaät tö', N'SOÅ CHI TIEÁT VAÄT TÖ', N'G05', N'2', N'0', N'Select * from vi0155', N'Order by InventoryID, VoucherDate, ImExOrders,VoucherNo', N'SOÅ CHI TIEÁT VAÄT TÖ', N'INVENTORY BOOKS', N'INVENTORY BOOKS', N'Inventory Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0361', N'Baùo caùo phaân tích toàn kho (möôøi coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0362', N'Baùo caùo phaân tích toàn kho (möôøi moät coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0372', N'Baùo caùo luyo keá toàn kho (12 coät)', N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', N'G05', N'22', N'0', null, null, N'BAÙO CAÙO LUOY KEÁ TOÀN KHO ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0374', N'Baùo caùo toàn kho theo mao phaân tích (30 coät)', N'BAÙO CAÙO TOÀN KHO THEO MAO PHAÂN TÍCH ', N'G05', N'23', N'0', null, null, N'BAÙO CAÙO TOÀN KHO THEO MAO PHAÂN TÍCH ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0180', N'Baùo caùo laoi suaát phaït vaø tieàn thöôûng (Toång hôïp - khoâng nhoùm)', N'LAOI XUAÁT VAØ TIEÀN THÖÔÛNG', N'G99', N'28', N'0', null, null, N'LAOI XUAÁT VAØ TIEÀN THÖÔÛNG', N'INTEREST AND BONUS', N'INTEREST AND BONUS', N'Interest and Bonus', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0107', N'Baùo caùo phaân boå coâng cuï duïng cuï trong kyø', N'PHAÂN BOÅ COÂNG CUÏ DUÏNG CUÏ', N'G08', N'0', N'0', N'Select * From vi0134', N'Order by GroupID, ToolID', N'PHAÂN BOÅ COÂNG CUÏ DUÏNG CUÏ', N'Equipment in period', N'EQUIPMENT IN PERIOD', N'Equipment in period', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0193', N'Baùo caùo coâng nôï theo maõ phaân tích (boán coät,moät caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'44', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0203', N'Baùo caùo coâng nôï theo maõ phaân tích (boán coät,2 caáp )', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'44', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0194', N'Baùo caùo coâng nôï theo maõ phaân tích (naêm coät,moät caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'45', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0213', N'Baùo caùo coâng nôï theo maõ phaân tích (naêm coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'45', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0205', N'Baùo caùo coâng nôï theo maõ phaân tích ( saùu coät‚2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'46', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0197', N'Baùo caùo coâng nôï theo maõ phaân tích (taùm coät,1 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'48', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0310', N'Soå chi tieát thanh toaùn vôùi ngöôøi mua baèng ngoaïi teä (NKSC)', N'SOÅ CHI TIEÁT THANH TOAÙN VÔÙI NGÖÔØI MUA BAÈNG NGOAÏI TEÄ', N'G03', N'1', N'0', N'Select * from tb0150 ', N' Order by AccountID, CurrencyID, ObjectID, Orders', N'SOÅ CHI TIEÁT THANH TOAÙN VÔÙI NGÖÔØI MUA BAÈNG NGOAÏI TEÄ', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0039', N'Baùo caùo doanh soá haøng mua theo maët haøng (nhoùm theo ñoái töôïng)', N'BAÙO CAÙO DOANH SOÁ HAØNG MUA THEO MAËT HAØNG', N'G07', N'5', N'1', N'Select * From vi0104 Order by ObjectID,InventoryID,InvoiceNo ', null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0150', N'Toång hôïp doanh soá baùn theo maët haøng, ñoái töôïng vaø giaù baùn', N'TOÅNG HÔÏP DOANH SOÁ BAÙN THEO MAËT HAØNG, ÑOÁI TÖÔÏNG VAØ GIAÙ BAÙN', N'G07', N'8', N'0', N'Select * from vi0199 Order by InventoryID, ObjectID, UnitPrice', null, N'TOÅNG HÔÏP DOANH SOÁ BAÙN THEO MAËT HAØNG, ÑOÁI TÖÔÏNG VAØ GIAÙ BAÙN', N'GENERAL SALES TURNOVER', N'GENERAL SALES TURNOVER', N'General Sales Turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0081', N'Baùo caùo toång hôïp toàn kho theo ñ?nh möùc', N'BAÙO CAÙO TOÅNG HÔÏP TOÀN KHO THEO Ñ?NH MÖÙC', N'G05', N'9', N'0', N'Select InventoryID,InventoryName,GroupTitle,GroupID,GroupName,DetailID,DetailName,QuantityOnHand,MaxQuantity,MinQuantity,ReOrderQuantity From vi0122 Order by GroupID,InventoryID,DetailID', null, N'BAÙO CAÙO TOÅNG HÔÏP TOÀN KHO THEO Ñ?NH MÖÙC', N'IN STOCK ACCORDING TO NORM', N'IN STOCK ACCORDING TO NORM', N'In Stock According to Norm', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0084', N'Baùo caùo kieåm tra toàn kho theo ñ?nh möùc', N'BAÙO CAÙO KIEÅM TRA TOÀN KHO THEO Ñ?NH MÖÙC', N'G05', N'10', N'0', N'Select InventoryID,InventoryName,GroupTitle,GroupID,GroupName,DetailID,DetailName,QuantityOnHand,MaxQuantity,MinQuantity,ReOrderQuantity From vi0330 Order by GroupID,InventoryID,DetailID', null, N'BAÙO CAÙO KIEÅM TRA TOÀN KHO THEO Ñ?NH MÖÙC', N'IN STOCK ACCORDING TO NORM', N'IN STOCK ACCORDING TO NORM', N'In Stock According to Norm', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0027', N'Baùo caùo chi tieát ñoái chieáu coâng nôï phaûi thu vaø phaûi traû (A4P)', N'BAÙO CAÙO CHI TIEÁT ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'G04', N'3', N'0', N'Select * From vi0087 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'BAÙO CAÙO CHI TIEÁT ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0327', N'Nhaät kyù thu chi qua ngaân haøng theo phieáu (nguyeân teä)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * From vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0328', N'Nhaät kyù thu chi qua ngaân haøng theo phieáu (nguyeân teä - quy ñoåi)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * From vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0309', N'Tôø khai thueá GTGT', N'TÔØ KHAI THUEÁ GTGT', N'G99', N'19', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0296', N'Chi tieát nôï phaûi thu (ñoái chieáu)', N'BAÛNG KEÂ ÑOÁI CHIEÁU NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'BAÛNG KEÂ ÑOÁI CHIEÁU NÔÏ PHAÛI THU', N'TO COMPARE RECEIVABLE', N'TO COMPARE RECEIVABLE', N'To Compare Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0272', N'Baûng caân ñoái soá phaùt sinh', N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'G99', N'2', N'0', null, null, N'BAÛNG CAÂN ÑOÁI SOÁ PHAÙT SINH', N'TRIAL BALANCE', N'TRIAL BALANCE', N'Trial Balance', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0320', N'Soå quy (nguyeân teä)', N'SOÅ QUY TIEÀN MAËT', N'G01', N'0', N'0', N'Select * From vi0297', N'Order by VoucherDate, TransactionTypeID, VoucherNo, Serial,InvoiceNo,DebitOriginalAmount, CreditOriginalAmount', N'SOÅ QUYO TIEÀN MAËT', N'CashBook', N'CashBook', N'CashBook (Original)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0344', N'Profit and loss statement (Part I)', N'PROFIT AND LOSS STATEMENT (PART I)', N'G99', N'7', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0285', N'Chi tieát nôï phaûi traû (in lieân tuïc)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0282', N'Chi tieát nôï phaûi traû (Ngteä - quy ñoåi)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable (Original - Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0185', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0147', N'Baùo caùo doanh soá baùn haøng', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'G07', N'2', N'0', N'Select * From vi0195 Order by InventoryID', null, N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0032', N'Baùo caùo chi tieát ñoái chieáu coâng nôï phaûi thu', N'BIEÂN BAÛN ÑOÁI CHIEÁU COÂNG NÔÏ TAÏM ÖÙNG', N'G04', N'3', N'0', N'Select * From vi0087 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'BIEÂN BAÛN ÑOÁI CHIEÁU COÂNG NÔÏ TAÏM ÖÙNG', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0358', N'Baùo caùo phaân tích toàn kho (Baûy coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0360', N'Baùo caùo phaân tích toàn kho (chín coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0364', N'Baùo caùo phaân tích toàn kho (möôøi ba coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0369', N'Baùo caùo phaân tích toàn kho (möôøi taùm coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0371', N'Baùo caùo phaân tích toàn kho ( hai möôi coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0179', N'Baùo caùo laõi suaát phaït vaø tieàn thöôûng (chi tieát - nhoùm)', null, N'G99', N'31', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0181', N'Baùo caùo laoi suaát phaït vaø tieàn thöôûng (Toång hôïp - khoâng nhoùm)', N'LAOI XUAÁT VAØ TIEÀN THÖÔÛNG', N'G99', N'29', N'0', null, null, N'LAOI XUAÁT VAØ TIEÀN THÖÔÛNG', N'INTEREST AND BONUS', N'INTEREST AND BONUS', N'Interest and Bonus', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0190', N'Baùo caùo coâng nôï theo maõ phaân tích (moät coät,1 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'41', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0200', N'Baùo caùo coâng nôï theo maõ phaân tích (moät coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'41', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0201', N'Baùo caùo coâng nôï theo maõ phaân tích (hai coät,2 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'42', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0211', N'Baùo caùo coâng nôï theo maõ phaân tích (ba coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'43', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0212', N'Baùo caùo coâng nôï theo maõ phaân tích (boán coät, 3 caáp )', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'44', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0195', N'Baùo caùo coâng nôï theo maõ phaân tích (saùu coät,1 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'46', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0214', N'Baùo caùo coâng nôï theo maõ phaân tích (saùu coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'46', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0196', N'Baùo caùo coâng nôï theo maõ phaân tích (7 coät,1 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'47', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0318', N'Soå chi phí saûn xuaát kinh doanh (NKSC)', N'SOÅ CHI PHÍ SAÛN XUAÁT KINH DOANH', N'G99', N'18', N'0', null, null, N'SOÅ CHI PHÍ SAÛN XUAÁT KINH DOANH', N'MANUFACTURING AND SALING COST BOOKS', N'MANUFACTURING AND SALING COST BOOKS', N'Manufacturing and Saling Cost Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0083', N'Danh muïc ñ?nh möùc toàn kho haøng hoùa (nhoùm theo loaïi d?nh möùc)', N'DANH MUÏC Ñ?NH MÖÙC TOÀN KHO HAØNG HOÙA', N'G05', N'8', N'0', N'Select InventoryName,tb0065.NormID,tb0064.Description,tb0065.InventoryID,tb0065.WareHouseID,tb0065.MinQuantity,tb0065.MaxQuantity,tb0065.ReOrderQuantity,WareHouseName From tb0065,tb0054,vi0118,tb0064 Where tb0065.InventoryID = tb0054.InventoryID AND tb0065.WareHouseID = vi0118.WareHouseID AND tb0065.NormID = tb0064.NormID', N'AT1314.NormID', N'DANH MUÏC Ñ?NH MÖÙC TOÀN KHO HAØNG HOÙA', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt2055', N'Danh s¸ch lao ®éng xÝ nghiÖp', N'Danh saùch lao ñoäng xí nghieäp', N'G09', N'0', N'0', N'Select * From vi2513', N'DepartmentID, Orders', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0028', N'Baùo caùo chi tieát ñoái chieáu coâng nôï phaûi thu vaø phaûi traû (A4L)', N'BAÙO CAÙO CHI TIEÁT ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'G04', N'3', N'0', N'Select * From vi0087 ', N' Order by GroupID ASC,R_P DESC,VoucherDate,VoucherNo,TransactionTypeID', N'BAÙO CAÙO CHI TIEÁT ÑOÁI CHIEÁU COÂNG NÔÏ PHAÛI THU VAØ PHAÛI TRAÛ', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'COMPARE RECEIVABLE AND PAYABLE DEBT', N'Compare Receivable and Payable Debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0325', N'Soå tieàn göûi ngaân haøng (nguyeân teä)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * from vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo ', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'CASH IN BANK BOOK', N'CASH IN BANK BOOK', N'Cash in Bank Book (Original)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0209', N'Baùo caùo coâng nôï theo maõ phaân tích (moät coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'41', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0330', N'Nhaät kyù thu chi qua ngaân haøng theo ngaøy (nguyeân teä - quy ñoåi)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * From vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'Receiving - Paying diary', N'RECEIVING - PAYING DIARY', N'Receiving - Paying diary (Original-Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0256', N'Baùo caùo xuaát kho theo boä', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', N'G05', N'12', N'0', N'Select * From AT7025', N'VoucherDate', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0184', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0248', N'Soå chi tieát vaät tö', N'SOÅ CHI TIEÁT VAÄT TÖ', N'G05', N'2', N'1', N'Select * from vi0155', N'Order by InventoryID, VoucherDate, ImExOrders,VoucherNo', N'SOÅ CHI TIEÁT VAÄT TÖ', N'INVENTORY BOOKS', N'INVENTORY BOOKS', N'Inventory Books', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0268', N'Soå caùi - Toång hôïp', N'SOÅ CAÙI TOÅNG HÔÏP', N'G99', N'1', N'0', N'Select * from vi0270', N'Order by  LinkAccountID, Period,CorAccountID ', N'SOÅ CAÙI TOÅNG HÔÏP', N'LEDGER', N'LEDGER', N'Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0346', N'Profit and loss statement (Part III)', N'PROFIT AND LOSS STATEMENT (PART III)', N'G99', N'27', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0169', N'Baùo caùo toång hôïp doanh soá baùn haøng theo mao phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'G07', N'6', N'0', N'Select * From vi0221 ', N' Order By Group1ID, Group2ID, Group3ID', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAO PHAÂN TÍCH', N'Analysis Code Sales', N'Analysis Code Sales', N'Analysis Code Sales', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0170', N'Baùo caùo toång hôïp doanh soá baùn haøng theo maõ phaân tích', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG THEO MAÕ PHAÂN TÍCH', N'G07', N'16', N'0', N'Select * From vi0221 ', N' Order By Group1ID, Group2ID', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0021', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'6', N'0', N'Select * From vi0073 Order By ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0321', N'Soå quyo (nguyeân teä - quy ñoåi)', N'SOÅ QUÕY TIEÀN MAËT', N'G01', N'0', N'0', N'Select * from vi0297', N'Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ QUYO TIEÀN MAËT', N'CashBook', N'CashBook', N'CashBook (Original-Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0260', N'Soå caùi - chi tieát - maau 1 (A4L)', N'SOÅ CAÙI CHI TIEÁT', N'G99', N'0', N'0', null, null, N'SOÅ CAÙI CHI TIEÁT', N'DETAIL LEDGER', N'DETAIL LEDGER', N'Detail Ledger', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0280', N'Chi tieát nôï phaûi thu (In lieân tuïc)', N'CHI TIEÁT NÔÏ PHAÛI THU', N'G03', N'1', N'0', N'Select * from vi0279 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI THU', N'DETAIL REPORT OF RECEIVABLE', N'DETAIL REPORT OF RECEIVABLE', N'Detail report of Receivable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0293', N'Toång hôïp Nôï phaûi traû (Ngoaïi teä)', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'G04', N'20', N'0', N'Select * from vi0282 ', N' Order by GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI TRAÛ', N'GENERAL PAYABLE DEBT', N'GENERAL PAYABLE DEBT', N'General Payable debt (Foreign currency)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0035', N'Baùo caùo chi tieát doanh soá haøng mua nhoùm 1 caáp', N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'G07', N'4', N'0', N'Select * From vi0103 Order by Group1ID,VoucherNo', null, N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'PURCHASING TURNOVER', N'PURCHASING TURNOVER', N'Purchasing turnover group by Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0146', N'Baùo caùo doanh soá baùn haøng', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'G07', N'1', N'0', N'Select * From vi0197 Order by InvoiceNo,ObjectID,InventoryID', N'', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0132', N'Baùo caùo nhaäp xuaát toàn taát caû caùc kho(nhoùm 1 caáp)', N'NHAÄP XUAÁT TOÀN', N'G05', N'5', N'1', N'Select * from vi0182', N'Order by  GroupID1, GroupID2, InventoryID', N'NHAÄP XUAÁT TOÀN', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory(Level 01)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0352', N'Baùo caùo phaân tích toàn kho (moät coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0354', N'Baùo caùo phaân tích toàn kho (ba coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0355', N'Baùo caùo phaân tích toàn kho (Boán coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0359', N'Baùo caùo phaân tích toàn kho (Taùm coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0366', N'Baùo caùo phaân tích toàn kho (möôøi laêm coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0178', N'Baùo caùo laõi suaát phaït vaø tieàn thöôûng (Toång hôïp - nhoùm)', null, N'G99', N'30', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0192', N'Baùo caùo coâng nôï theo maõ phaân tích (ba coät,moät caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'43', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0221', N'Baùo caùo coâng nôï theo maõ phaân tích (boán coät, 4 caáp )', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'44', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0312', N'Soå theo doõi thanh toaùn baèng ngoaïi teä (NKSC)', N'SOÅ THEO DOÕI THANH TOAÙN BAÈNG NGOAÏI TEÄ', N'G99', N'11', N'0', N'Select * from tb0150 Order by AccountID, CurrencyID, ObjectID, Orders', null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0101', N'Soå taøi saûn coá ñ?nh (NKSC)', N'SOÅ TAØI SAÛN COÁ Ñ?NH', N'G02', N'1', N'0', N'Select * from vi0130 Order by GroupID, AssetID', null, N'SOÅ TAØI SAÛN COÁ Ñ?NH', N'AssetBook', N'ASSETBOOK', N'AssetBook', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0082', N'Danh muïc ñ?nh möùc toàn kho haøng hoùa (nhoùm theo kho haøng)', N'DANH MUÏC Ñ?NH MÖÙC TOÀN KHO HAØNG HOÙA', N'G05', N'7', N'0', N'Select * from vi0388 ', N'Order by Orders,VoucherDate, VoucherNo', N'DANH MUÏC Ñ?NH MÖÙC TOÀN KHO HAØNG HOÙA', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0326', N'Soå tieàn göûi ngaân haøng (nguyeân teä - quy ñoåi)', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'G01', N'1', N'0', N'Select * from vi0298 ', N' Order by VoucherDate, TransactionTypeID, VoucherNo, Serial, InvoiceNo', N'SOÅ TIEÀN GÖÛI NGAÂN HAØNG', N'CASH IN BANK BOOK', N'CASH IN BANK BOOK', N'Cash in Bank Book (Original-Converted)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0255', N'Baùo caùo xuaát kho theo boä', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', N'G05', N'11', N'0', N'Select * From AT7025', N'ProductID, ApportionID', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0258', N'Baùo caùo xuaát kho theo boä', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', N'G05', N'14', N'0', N'Select * From AT7025', N'VoucherDate, VoucherID, Orders, MaterialID', N'BAÙO CAÙO XUAÁT KHO THEO BOÄ', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0411', N'Nhaät kyù nhaäp xuaát kho', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'G05', N'3', N'1', N'Select * from tb0111', N'Order by WareHouseID, Orders', N'NHAÄT KYÙ NHAÄP XUAÁT KHO', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'RECEIVING - DELIVERING - INVENTORY DIARY', N'Receiving - Delivering - Inventory Diary', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0281', N'Chi tieát nôï phaûi traû (taùch trang)', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'G04', N'1', N'0', N'Select * from vi0281 ', N' Order by GroupID, ObjectID, VoucherDate, VoucherNo', N'CHI TIEÁT NÔÏ PHAÛI TRAÛ', N'DETAIL REPORT OF PAYABLE', N'DETAIL REPORT OF PAYABLE', N'Detail report of Payable', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0227', N'Baùo caùo chi tieát theo hoaù ñôn', N'BAÙO CAÙO CHI TIEÁT THEO HOAÙ ÑÔN', N'G99', N'40', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0151', N'Toång hôïp doanh soá mua theo maët haøng, ñoái töôïng vaø giaù mua', N'TOÅNG HÔÏP DOANH SOÁ MUA THEO MAËT HAØNG, ÑOÁI TÖÔÏNG VAØ GIAÙ MUA', N'G07', N'9', N'0', N'Select * from vi0201 Order by InventoryID, ObjectID, UnitPrice', null, N'TOÅNG HÔÏP DOANH SOÁ MUA THEO MAËT HAØNG, ÑOÁI TÖÔÏNG VAØ GIAÙ MUA', N'GENERAL PURCHASING TURNOVER', N'GENERAL PURCHASING TURNOVER', N'General Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0244', N'Cash flow', N'CASH FLOW', N'G99', N'8', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0217', N'Baùo caùo coâng nôï theo maõ phaân tích (chín coät,3 caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'49', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0041', N'Baùo caùo chi tieát doanh soá haøng mua nhoùm 2 caáp', N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'G07', N'14', N'0', N'Select * From vi0103 Order by Group1ID,Group2ID,VoucherNo', null, N'BAÙO CAÙO CHI TIEÁT DOANH SOÁ HAØNG MUA', N'PURCHASING TURNOVER', N'PURCHASING TURNOVER', N'Purchasing turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0187', N'Baùo caùo phaân tích taøi chính daïng 1 (03 coät)', N'', N'G99', N'6', N'0', N' Select *  From vi0243 ', N' Order by  Level00, Level01,Level02,Level03', N'Baùo caùo phaân tích taøi chính daïng 1', N'Baùo caùo phaân tích taøi chính daïng 1', N'', N'Baùo caùo phaân tích taøi chính daïng 1 (03 coät)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0131', N'Baùo caùo nhaäp xuaát toàn taát caû caùc kho', N'NHAÄP XUAÁT TOÀN', N'G05', N'5', N'0', N'Select * from vi0182', N'Order by  GroupID1, GroupID2, InventoryID', N'NHAÄP XUAÁT TOÀN', N'RECEIVING - DELIVERING - INVENTORY', N'RECEIVING - DELIVERING - INVENTORY', N'Receiving - Delivering - Inventory', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0019', N'Baùo caùo chi tieát phaân tích coâng nôï theo tuoåi nô', N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', N'G03', N'26', N'0', N'Select * From vi0073 Order By Group1, Group2, ObjectID', null, N'BAÙO CAÙO CHI TIEÁT PHAÂN TÍCH COÂNG NÔÏ THEO TUOÅI NÔ%', null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0316', N'Toång hôïp Nôï phaûi thu (taát caû loaïi tieàn - Qui ñoåi )', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'G03', N'10', N'0', N' Select * from vi0277', N' Order by GroupID,GroupID1, GroupID2 ', N'TOÅNG HÔÏP NÔÏ PHAÛI THU', N'GENERAL RECEIVABLE DEBT', N'GENERAL RECEIVABLE DEBT', N'General Receivable debt', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0129', N'Baùo caùo toàn kho theo taøi khoaûn (Nhoùm theo kho)', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN (NHOÙM THEO KHO)', N'G05', N'20', N'0', N'Select * From vi0149 ', N' Order by WareHouseID, InventoryID', N'BAÙO CAÙO TOÀN KHO THEO TAØI KHOAÛN (NHOÙM THEO KHO)', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT (Group WareHouse)', N'RECEIVING - DELIVERING - INVENTORY BY ACCOUNT (Group WareHouse)', N'Receiving - Delivering - Inventory (By Account, Group WareHouse)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0391', N'Baùo caùo phaân tích TC daïng 2 (Nhieu Cot, Custermize)', null, N'G99', N'10', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0395', N'Soå taøi khoaûn ngoaøi baûng (toång hôïp)', N'SOÅ TAØI KHOAÛN NGOAØI BAÛNG', N'G99', N'98', N'0', N'Select * from vi0383', N'Order by InventoryID', N'SOÅ TAØI KHOAÛN NGOAØI BAÛNG', N'OUT TABLE ACCOUNT TABLE', N'OUT TABLE ACCOUNT TABLE', N'Out table account book (general)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0008', N'Baùo caùo toång hôïp cuoái kyø theo loâ', N'Baùo caùo toång hôïp cuoái kyø theo loâ', N'G05', N'30', N'1', N'', N'', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0408', N'Baùo caùo chi tieát nhaäp xuaát toàn theo FIFO', N'BAÙO CAÙO CHI TIEÁT NHAÄP XUAÁT TOÀN THEO FIFO', N'G05', N'31', N'1', N'Select * from vi0181', N'Order by InventoryID,type,VoucherDate,VoucherNo,FromVoucherDate,TransactionID', N'BAÙO CAÙO CHI TIEÁT NHAÄP XUAÁT TOÀN THEO FIFO', N'RECEIVING - DELIVERING - INVENTORY BYFIFO', N'RECEIVING - DELIVERING - INVENTORY BY MONTH', N'Receiving - Delivering - Inventory (FIFO)', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0414', N'Baùo caùo doanh soá baùn haøng chi tieát theo hoùa ñôan', N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG CHI TIEÁT THEO HOAÙ ÑÔN', N'G07', N'1', N'0', N'Select * From vi0197 Order by InvoiceNo,InvoiceDate,ObjectID,InventoryID', null, N'BAÙO CAÙO DOANH SOÁ BAÙN HAØNG CHI TIEÁT THEO HOAÙ ÑÔN', N'SALES TURNOVER', N'SALES TURNOVER', N'Sales turnover', N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0007', N'Baùo caùo nhaäp xuaát toàn toång hôïp theo loâ', N'BAÙO CAÙO NHAÄP XUAÁT TOÀN TOÅNG HÔÏP THEO LOÂ', N'G05', N'30', N'1', N'', N'', null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0220', N'Baùo caùo coâng nôï theo maõ phaân tích (ba coät,boán caáp)', N'BAÙO CAÙO COÂNG NÔÏ THEO MAÕ PHAÂN TÍCH', N'G99', N'43', N'0', null, null, null, null, null, null, N'')
GO
GO
INSERT INTO [dbo].[tb0189] ([ReportID], [ReportName], [Title], [GroupID], [Type], [Disabled], [SQLstring], [Orderby], [Description], [DescriptionE], [TitleE], [ReportNameE], [GroupShow]) VALUES (N'rpt0356', N'Baùo caùo phaân tích toàn kho (Naêm coät)', N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', N'G05', N'21', N'0', null, null, N'BAÙO CAÙO PHAÂN TÍCH TOÀN KHO', null, null, null, N'')
GO
GO
